package com.ruoyi.pingjiao.mapper;

import com.ruoyi.pingjiao.domain.Score;
import com.ruoyi.pingjiao.domain.vo.ScoreVo;
import com.ruoyi.pingjiao.domain.vo.StudentInfoVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;
@Mapper
public interface ScoreMapper {
    void save(Score score);
    List<Double> selectFinish(int i);

    int countStudentByCourseId(Integer courseId);

    Score selectByCourseassessNameIdAndStudentNo(@Param("courseassessNameId") Long courseassessNameId, @Param("studentNo")String studentNo);

    Score selectByCoureassessIdCourseassessNameIdAndStudentNo(@Param("courseassessId") Long courseassessId, @Param("courseassessNameId") Long courseassessNameId, @Param("studentNo")String studentNo);

    ScoreVo selectFenbu(Integer courseassessId);
    List<Score> selectStudentByCourseId(Long courseId);

    List<StudentInfoVo> selectStudentInfo(Map<String, Object> map);

    Double selectScoreByName(Map<String, Object> map);

    ScoreVo countRate(Integer courseId);

    Score selectMaxAndMin(Map<String, Object> map);

    List<Score> selectNameByTeacherId(Map<String, Object> map);

    List<Score> list(Score score);

    int add(Score score);

    int update(Score score);

    int delete(Long id);

    Score selectByName(Map<String, Object> map);

    void updateWokeName();

//    void updateInfo(Score score);

    void deleteByCourseId(Integer courseId);

    List<Score> getScoreByCourseId(Integer courseId);

    List<Double> getScoreById(Long id);
}
